Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	46513
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.1 MiB
Average record size in memory	160.0 B

Variable types

Categorical	12
Numeric	8

Alerts

`Project Name` has a high cardinality: 2498 distinct values	High cardinality
`Address` has a high cardinality: 46468 distinct values	High cardinality
`Nett Price($)` has a high cardinality: 144 distinct values	High cardinality
`Sale Date` has a high cardinality: 698 distinct values	High cardinality
`Tenure` has a high cardinality: 576 distinct values	High cardinality
`Completion Date` has a high cardinality: 75 distinct values	High cardinality
`Area (sqm)` is highly overall correlated with `Transacted Price ($)`	High correlation
`Transacted Price ($)` is highly overall correlated with `Area (sqm)`	High correlation
`Unit Price ($ psm)` is highly overall correlated with `Unit Price ($ psf)` and 3 other fields	High correlation
`Unit Price ($ psf)` is highly overall correlated with `Unit Price ($ psm)` and 3 other fields	High correlation
`Postal District` is highly overall correlated with `Unit Price ($ psm)` and 5 other fields	High correlation
`Postal Sector` is highly overall correlated with `Unit Price ($ psm)` and 5 other fields	High correlation
`Postal Code` is highly overall correlated with `Unit Price ($ psm)` and 5 other fields	High correlation
`Type of Area` is highly overall correlated with `Property Type` and 1 other fields	High correlation
`Property Type` is highly overall correlated with `Type of Area`	High correlation
`Completion Date` is highly overall correlated with `Type of Area` and 1 other fields	High correlation
`Type of Sale` is highly overall correlated with `Completion Date`	High correlation
`Planning Region` is highly overall correlated with `Postal District` and 3 other fields	High correlation
`Planning Area` is highly overall correlated with `Postal District` and 3 other fields	High correlation
`Type of Area` is highly imbalanced (60.1%)	Imbalance
`Nett Price($)` is highly imbalanced (99.2%)	Imbalance
`No. of Units` is highly skewed (γ1 = 63.42668718)	Skewed
`Area (sqm)` is highly skewed (γ1 = 60.40826919)	Skewed
`Transacted Price ($)` is highly skewed (γ1 = 48.22169828)	Skewed
`Address` is uniformly distributed	Uniform

Reproduction

Analysis started	2023-04-19 12:19:16.960337
Analysis finished	2023-04-19 12:19:22.082281
Duration	5.12 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

Project Name
Categorical

Distinct	2498
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

N.A.	1564
RIVERFRONT RESIDENCES	938
RIVERCOVE RESIDENCES	620
THE TAPESTRY	613
STIRLING RESIDENCES	598
Other values (2493)	42180

Length

Max length	47
Median length	28
Mean length	13.893557
Min length	2

Characters and Unicode

Total characters	646231
Distinct characters	44
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	463 ?
Unique (%)	1.0%

Sample

1st row	THE BAYSHORE
2nd row	KINGSFORD WATERBAY
3rd row	THE JOVELL
4th row	V ON SHENTON
5th row	THE BEACON

Common Values

Value	Count	Frequency (%)
N.A.	1564	3.4%
RIVERFRONT RESIDENCES	938	2.0%
RIVERCOVE RESIDENCES	620	1.3%
THE TAPESTRY	613	1.3%
STIRLING RESIDENCES	598	1.3%
PARK COLONIAL	579	1.2%
PARC BOTANNIA	535	1.2%
HUNDRED PALMS RESIDENCES	531	1.1%
KINGSFORD WATERBAY	516	1.1%
PARC ESTA	483	1.0%
Other values (2488)	39536	85.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	8018	8.1%
residences	7926	8.0%
park	3478	3.5%
parc	2265	2.3%
at	1996	2.0%
n.a	1564	1.6%
condominium	1068	1.1%
	1066	1.1%
residence	1004	1.0%
riverfront	938	1.0%
Other values (1884)	69245	70.3%

Most occurring characters

Value	Count	Frequency (%)
E	87371	13.5%
R	52577	8.1%
A	52342	8.1%
	52055	8.1%
S	48972	7.6%
N	45495	7.0%
I	45482	7.0%
T	38444	5.9%
O	28607	4.4%
L	23883	3.7%
Other values (34)	171003	26.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	586138	90.7%
Space Separator	52055	8.1%
Other Punctuation	5034	0.8%
Decimal Number	2881	0.4%
Dash Punctuation	123	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	87371	14.9%
R	52577	9.0%
A	52342	8.9%
S	48972	8.4%
N	45495	7.8%
I	45482	7.8%
T	38444	6.6%
O	28607	4.9%
L	23883	4.1%
C	23429	4.0%
Other values (16)	139536	23.8%

Decimal Number

Value	Count	Frequency (%)
8	780	27.1%
1	423	14.7%
3	405	14.1%
2	353	12.3%
6	242	8.4%
5	236	8.2%
0	181	6.3%
4	146	5.1%
7	62	2.2%
9	53	1.8%

Other Punctuation

Value	Count	Frequency (%)
.	3152	62.6%
@	1332	26.5%
'	509	10.1%
&	28	0.6%
#	8	0.2%
/	5	0.1%

Space Separator

Value	Count	Frequency (%)
	52055	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	123	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	586138	90.7%
Common	60093	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	87371	14.9%
R	52577	9.0%
A	52342	8.9%
S	48972	8.4%
N	45495	7.8%
I	45482	7.8%
T	38444	6.6%
O	28607	4.9%
L	23883	4.1%
C	23429	4.0%
Other values (16)	139536	23.8%

Common

Value	Count	Frequency (%)
	52055	86.6%
.	3152	5.2%
@	1332	2.2%
8	780	1.3%
'	509	0.8%
1	423	0.7%
3	405	0.7%
2	353	0.6%
6	242	0.4%
5	236	0.4%
Other values (8)	606	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	646231	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	87371	13.5%
R	52577	8.1%
A	52342	8.1%
	52055	8.1%
S	48972	7.6%
N	45495	7.0%
I	45482	7.0%
T	38444	5.9%
O	28607	4.4%
L	23883	3.7%
Other values (34)	171003	26.5%

Address
Categorical

HIGH CARDINALITY UNIFORM

Distinct	46468
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

36 Dakota Crescent #14-05	2
139 Cavenagh Road #06-06	2
21 Meyappa Chettiar Road #03-02	2
21 Meyappa Chettiar Road #02-01	2
7 Still Lane	2
Other values (46463)	46503

Length

Max length	59
Median length	47
Mean length	26.408423
Min length	11

Characters and Unicode

Total characters	1228335
Distinct characters	69
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	46423 ?
Unique (%)	99.8%

Sample

1st row	22 Bayshore Road #03-02
2nd row	66 Upper Serangoon View #16-12
3rd row	13 Flora Drive #02-11
4th row	5A Shenton Way #44-12
5th row	130 Cantonment Road #10-04

Common Values

Value	Count	Frequency (%)
36 Dakota Crescent #14-05	2	< 0.1%
139 Cavenagh Road #06-06	2	< 0.1%
21 Meyappa Chettiar Road #03-02	2	< 0.1%
21 Meyappa Chettiar Road #02-01	2	< 0.1%
7 Still Lane	2	< 0.1%
60 Jalan Lengkok Sembawang	2	< 0.1%
12 West Coast Crescent #01-08	2	< 0.1%
10 Martin Place #11-13	2	< 0.1%
336 River Valley Road #07-01	2	< 0.1%
103 Pasir Ris Grove #01-08	2	< 0.1%
Other values (46458)	46493	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
road	13707	6.5%
avenue	6255	3.0%
street	4372	2.1%
1	3267	1.6%
drive	2978	1.4%
jalan	1915	0.9%
3	1877	0.9%
7	1871	0.9%
view	1864	0.9%
lane	1854	0.9%
Other values (5389)	169952	81.0%

Most occurring characters

Value	Count	Frequency (%)
	251797	20.5%
e	70727	5.8%
a	65379	5.3%
0	57247	4.7%
1	55488	4.5%
o	49612	4.0%
n	47068	3.8%
-	41917	3.4%
#	41870	3.4%
r	36291	3.0%
Other values (59)	510939	41.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	502887	40.9%
Decimal Number	273177	22.2%
Space Separator	251797	20.5%
Uppercase Letter	116064	9.4%
Other Punctuation	42425	3.5%
Dash Punctuation	41917	3.4%
Open Punctuation	34	< 0.1%
Close Punctuation	34	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	70727	14.1%
a	65379	13.0%
o	49612	9.9%
n	47068	9.4%
r	36291	7.2%
i	31794	6.3%
t	26913	5.4%
l	22095	4.4%
d	21179	4.2%
s	20865	4.1%
Other values (16)	110964	22.1%

Uppercase Letter

Value	Count	Frequency (%)
R	17187	14.8%
S	13035	11.2%
C	11067	9.5%
A	9599	8.3%
L	7167	6.2%
P	6397	5.5%
B	5818	5.0%
T	5628	4.8%
W	4946	4.3%
D	4337	3.7%
Other values (15)	30883	26.6%

Decimal Number

Value	Count	Frequency (%)
0	57247	21.0%
1	55488	20.3%
2	33944	12.4%
3	27423	10.0%
5	20054	7.3%
4	18096	6.6%
6	18084	6.6%
8	15554	5.7%
7	14944	5.5%
9	12343	4.5%

Other Punctuation

Value	Count	Frequency (%)
#	41870	98.7%
.	265	0.6%
'	182	0.4%
/	108	0.3%

Space Separator

Value	Count	Frequency (%)
	251797	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	41917	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	34	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	34	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	618951	50.4%
Common	609384	49.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	70727	11.4%
a	65379	10.6%
o	49612	8.0%
n	47068	7.6%
r	36291	5.9%
i	31794	5.1%
t	26913	4.3%
l	22095	3.6%
d	21179	3.4%
s	20865	3.4%
Other values (41)	227028	36.7%

Common

Value	Count	Frequency (%)
	251797	41.3%
0	57247	9.4%
1	55488	9.1%
-	41917	6.9%
#	41870	6.9%
2	33944	5.6%
3	27423	4.5%
5	20054	3.3%
4	18096	3.0%
6	18084	3.0%
Other values (8)	43464	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1228335	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	251797	20.5%
e	70727	5.8%
a	65379	5.3%
0	57247	4.7%
1	55488	4.5%
o	49612	4.0%
n	47068	3.8%
-	41917	3.4%
#	41870	3.4%
r	36291	3.0%
Other values (59)	510939	41.6%

No. of Units
Real number (ℝ)

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1268248

Minimum	1
Maximum	560
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	560
Range	559
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.3747962
Coefficient of variation (CV)	4.7698599
Kurtosis	4844.7169
Mean	1.1268248
Median Absolute Deviation (MAD)	0
Skewness	63.426687
Sum	52412
Variance	28.888434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	46427	99.8%
2	12	< 0.1%
20	5	< 0.1%
32	4	< 0.1%
3	4	< 0.1%
4	3	< 0.1%
11	3	< 0.1%
12	3	< 0.1%
14	2	< 0.1%
6	2	< 0.1%
Other values (43)	48	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	46427	99.8%
2	12	< 0.1%
3	4	< 0.1%
4	3	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
8	2	< 0.1%
11	3	< 0.1%
12	3	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
560	1	< 0.1%
436	1	< 0.1%
336	1	< 0.1%
330	1	< 0.1%
290	1	< 0.1%
288	1	< 0.1%
286	1	< 0.1%
244	1	< 0.1%
210	1	< 0.1%
200	1	< 0.1%

Area (sqm)
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	862
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	140.18962

Minimum	24
Maximum	87986
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	24
5-th percentile	44
Q1	70
median	98
Q3	129
95-th percentile	290
Maximum	87986
Range	87962
Interquartile range (IQR)	59

Descriptive statistics

Standard deviation	841.24481
Coefficient of variation (CV)	6.0007637
Kurtosis	4503.7
Mean	140.18962
Median Absolute Deviation (MAD)	29
Skewness	60.408269
Sum	6520640
Variance	707692.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43	709	1.5%
103	680	1.5%
89	670	1.4%
91	625	1.3%
85	596	1.3%
84	590	1.3%
99	581	1.2%
98	556	1.2%
65	548	1.2%
57	543	1.2%
Other values (852)	40415	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24	1	< 0.1%
30	3	< 0.1%
31	12	< 0.1%
32	23	< 0.1%
33	33	0.1%
34	68	0.1%
35	39	0.1%
36	54	0.1%
37	96	0.2%
38	78	0.2%

Value	Count	Frequency (%)
87986	1	< 0.1%
58460	1	< 0.1%
52381	1	< 0.1%
51892	1	< 0.1%
48347	1	< 0.1%
44541	1	< 0.1%
38717	1	< 0.1%
37636	1	< 0.1%
35574	1	< 0.1%
33920	1	< 0.1%

Type of Area
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Strata	42834
Land	3679

Length

Max length	6
Median length	6
Mean length	5.8418077
Min length	4

Characters and Unicode

Total characters	271720
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Strata
2nd row	Strata
3rd row	Strata
4th row	Strata
5th row	Strata

Common Values

Value	Count	Frequency (%)
Strata	42834	92.1%
Land	3679	7.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
strata	42834	92.1%
land	3679	7.9%

Most occurring characters

Value	Count	Frequency (%)
a	89347	32.9%
t	85668	31.5%
S	42834	15.8%
r	42834	15.8%
L	3679	1.4%
n	3679	1.4%
d	3679	1.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	225207	82.9%
Uppercase Letter	46513	17.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	89347	39.7%
t	85668	38.0%
r	42834	19.0%
n	3679	1.6%
d	3679	1.6%

Uppercase Letter

Value	Count	Frequency (%)
S	42834	92.1%
L	3679	7.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	271720	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	89347	32.9%
t	85668	31.5%
S	42834	15.8%
r	42834	15.8%
L	3679	1.4%
n	3679	1.4%
d	3679	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	271720	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	89347	32.9%
t	85668	31.5%
S	42834	15.8%
r	42834	15.8%
L	3679	1.4%
n	3679	1.4%
d	3679	1.4%

Transacted Price ($)
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	9824
Distinct (%)	21.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2087292.7

Minimum	358000
Maximum	9.8 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	358000
5-th percentile	682000
Q1	930000
median	1267000
Q3	1840292
95-th percentile	4036560
Maximum	9.8 × 10⁸
Range	9.79642 × 10⁸
Interquartile range (IQR)	910292

Descriptive statistics

Standard deviation	14186311
Coefficient of variation (CV)	6.7965123
Kurtosis	2677.4329
Mean	2087292.7
Median Absolute Deviation (MAD)	397000
Skewness	48.221698
Sum	9.7086247 × 10¹⁰
Variance	2.0125141 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1200000	313	0.7%
1100000	304	0.7%
1300000	272	0.6%
1050000	261	0.6%
1500000	258	0.6%
1150000	255	0.5%
1400000	227	0.5%
1350000	215	0.5%
1250000	210	0.5%
1180000	207	0.4%
Other values (9814)	43991	94.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
358000	1	< 0.1%
362000	1	< 0.1%
369000	1	< 0.1%
371000	1	< 0.1%
373000	1	< 0.1%
376000	2	< 0.1%
380000	1	< 0.1%
383000	1	< 0.1%
388000	1	< 0.1%
392000	2	< 0.1%

Value	Count	Frequency (%)
980000000	1	< 0.1%
970000000	1	< 0.1%
906889000	1	< 0.1%
906700000	1	< 0.1%
840888888	1	< 0.1%
765781819	1	< 0.1%
728000000	1	< 0.1%
629000000	1	< 0.1%
610000000	1	< 0.1%
575000000	1	< 0.1%

Nett Price($)
Categorical

HIGH CARDINALITY IMBALANCE

Distinct	144
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

-	46363
895000	2
889000	2
887000	2
802700	2
Other values (139)	142

Length

Max length	7
Median length	1
Mean length	1.01778
Min length	1

Characters and Unicode

Total characters	47340
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	136 ?
Unique (%)	0.3%

Sample

1st row	-
2nd row	-
3rd row	-
4th row	2847680
5th row	-

Common Values

Value	Count	Frequency (%)
-	46363	99.7%
895000	2	< 0.1%
889000	2	< 0.1%
887000	2	< 0.1%
802700	2	< 0.1%
1296000	2	< 0.1%
853000	2	< 0.1%
868420	2	< 0.1%
842000	1	< 0.1%
936000	1	< 0.1%
Other values (134)	134	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	46363	99.7%
889000	2	< 0.1%
887000	2	< 0.1%
802700	2	< 0.1%
1296000	2	< 0.1%
853000	2	< 0.1%
868420	2	< 0.1%
895000	2	< 0.1%
2644505	1	< 0.1%
850000	1	< 0.1%
Other values (134)	134	0.3%

Most occurring characters

Value	Count	Frequency (%)
-	46363	97.9%
0	335	0.7%
1	121	0.3%
8	92	0.2%
4	72	0.2%
9	69	0.1%
7	66	0.1%
2	63	0.1%
3	58	0.1%
5	54	0.1%

Most occurring categories

Value	Count	Frequency (%)
Dash Punctuation	46363	97.9%
Decimal Number	977	2.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	335	34.3%
1	121	12.4%
8	92	9.4%
4	72	7.4%
9	69	7.1%
7	66	6.8%
2	63	6.4%
3	58	5.9%
5	54	5.5%
6	47	4.8%

Dash Punctuation

Value	Count	Frequency (%)
-	46363	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	47340	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	46363	97.9%
0	335	0.7%
1	121	0.3%
8	92	0.2%
4	72	0.2%
9	69	0.1%
7	66	0.1%
2	63	0.1%
3	58	0.1%
5	54	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	46363	97.9%
0	335	0.7%
1	121	0.3%
8	92	0.2%
4	72	0.2%
9	69	0.1%
7	66	0.1%
2	63	0.1%
3	58	0.1%
5	54	0.1%

Unit Price ($ psm)
Real number (ℝ)

Distinct	15812
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14759.852

Minimum	1503
Maximum	54363
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	1503
5-th percentile	8010
Q1	10714
median	14190
Q3	17647
95-th percentile	24501.6
Maximum	54363
Range	52860
Interquartile range (IQR)	6933

Descriptive statistics

Standard deviation	5424.0907
Coefficient of variation (CV)	0.36748951
Kurtosis	2.8702761
Mean	14759.852
Median Absolute Deviation (MAD)	3469
Skewness	1.2611516
Sum	6.8652498 × 10⁸
Variance	29420759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	137	0.3%
15000	86	0.2%
16667	78	0.2%
12500	75	0.2%
20000	69	0.1%
13333	61	0.1%
14286	57	0.1%
14000	56	0.1%
16000	50	0.1%
11111	49	0.1%
Other values (15802)	45795	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1503	1	< 0.1%
1802	1	< 0.1%
1809	1	< 0.1%
2131	1	< 0.1%
2433	1	< 0.1%
2659	1	< 0.1%
2771	1	< 0.1%
3032	1	< 0.1%
3056	1	< 0.1%
3251	1	< 0.1%

Value	Count	Frequency (%)
54363	1	< 0.1%
53030	1	< 0.1%
49835	1	< 0.1%
49080	1	< 0.1%
46667	1	< 0.1%
46281	1	< 0.1%
44984	1	< 0.1%
44940	1	< 0.1%
44892	1	< 0.1%
44433	1	< 0.1%

Unit Price ($ psf)
Real number (ℝ)

Distinct	2840
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1371.223

Minimum	140
Maximum	5050
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	140
5-th percentile	744
Q1	995
median	1318
Q3	1639
95-th percentile	2276.4
Maximum	5050
Range	4910
Interquartile range (IQR)	644

Descriptive statistics

Standard deviation	503.9075
Coefficient of variation (CV)	0.36748764
Kurtosis	2.8704244
Mean	1371.223
Median Absolute Deviation (MAD)	322
Skewness	1.2611819
Sum	63779695
Variance	253922.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
929	139	0.3%
1548	103	0.2%
1394	93	0.2%
1327	84	0.2%
1161	79	0.2%
1858	73	0.2%
1301	72	0.2%
1032	72	0.2%
1239	72	0.2%
1340	68	0.1%
Other values (2830)	45658	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
140	1	< 0.1%
167	1	< 0.1%
168	1	< 0.1%
198	1	< 0.1%
226	1	< 0.1%
247	1	< 0.1%
257	1	< 0.1%
282	1	< 0.1%
284	1	< 0.1%
302	1	< 0.1%

Value	Count	Frequency (%)
5050	1	< 0.1%
4927	1	< 0.1%
4630	1	< 0.1%
4560	1	< 0.1%
4335	1	< 0.1%
4300	1	< 0.1%
4179	1	< 0.1%
4175	1	< 0.1%
4171	1	< 0.1%
4128	1	< 0.1%

Sale Date
Categorical

Distinct	698
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

05-JUL-2018	1000
22-JUL-2017	591
14-APR-2018	466
05-MAY-2018	377
05-AUG-2017	309
Other values (693)	43770

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	511643
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	28-FEB-2019
2nd row	28-FEB-2019
3rd row	28-FEB-2019
4th row	28-FEB-2019
5th row	28-FEB-2019

Common Values

Value	Count	Frequency (%)
05-JUL-2018	1000	2.1%
22-JUL-2017	591	1.3%
14-APR-2018	466	1.0%
05-MAY-2018	377	0.8%
05-AUG-2017	309	0.7%
22-SEP-2018	309	0.7%
24-MAR-2018	307	0.7%
23-MAR-2019	249	0.5%
11-NOV-2017	236	0.5%
07-APR-2018	229	0.5%
Other values (688)	42440	91.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
05-jul-2018	1000	2.1%
22-jul-2017	591	1.3%
14-apr-2018	466	1.0%
05-may-2018	377	0.8%
05-aug-2017	309	0.7%
22-sep-2018	309	0.7%
24-mar-2018	307	0.7%
23-mar-2019	249	0.5%
11-nov-2017	236	0.5%
07-apr-2018	229	0.5%
Other values (688)	42440	91.2%

Most occurring characters

Value	Count	Frequency (%)
-	93026	18.2%
2	67174	13.1%
1	66203	12.9%
0	65105	12.7%
8	27940	5.5%
7	23499	4.6%
A	19398	3.8%
U	14258	2.8%
J	12877	2.5%
N	11006	2.2%
Other values (20)	111157	21.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	279078	54.5%
Uppercase Letter	139539	27.3%
Dash Punctuation	93026	18.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	19398	13.9%
U	14258	10.2%
J	12877	9.2%
N	11006	7.9%
M	9423	6.8%
E	9333	6.7%
O	7690	5.5%
R	6971	5.0%
P	6673	4.8%
C	6540	4.7%
Other values (9)	35370	25.3%

Decimal Number

Value	Count	Frequency (%)
2	67174	24.1%
1	66203	23.7%
0	65105	23.3%
8	27940	10.0%
7	23499	8.4%
9	7950	2.8%
3	6751	2.4%
5	5574	2.0%
4	4726	1.7%
6	4156	1.5%

Dash Punctuation

Value	Count	Frequency (%)
-	93026	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	372104	72.7%
Latin	139539	27.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	19398	13.9%
U	14258	10.2%
J	12877	9.2%
N	11006	7.9%
M	9423	6.8%
E	9333	6.7%
O	7690	5.5%
R	6971	5.0%
P	6673	4.8%
C	6540	4.7%
Other values (9)	35370	25.3%

Common

Value	Count	Frequency (%)
-	93026	25.0%
2	67174	18.1%
1	66203	17.8%
0	65105	17.5%
8	27940	7.5%
7	23499	6.3%
9	7950	2.1%
3	6751	1.8%
5	5574	1.5%
4	4726	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	511643	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	93026	18.2%
2	67174	13.1%
1	66203	12.9%
0	65105	12.7%
8	27940	5.5%
7	23499	4.6%
A	19398	3.8%
U	14258	2.8%
J	12877	2.5%
N	11006	2.2%
Other values (20)	111157	21.7%

Property Type
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Condominium	22283
Apartment	15225
Executive Condominium	4562
Terrace House	2760
Semi-Detached House	1225

Length

Max length	21
Median length	19
Mean length	11.685056
Min length	9

Characters and Unicode

Total characters	543507
Distinct characters	25
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Condominium
2nd row	Apartment
3rd row	Condominium
4th row	Apartment
5th row	Apartment

Common Values

Value	Count	Frequency (%)
Condominium	22283	47.9%
Apartment	15225	32.7%
Executive Condominium	4562	9.8%
Terrace House	2760	5.9%
Semi-Detached House	1225	2.6%
Detached House	458	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
condominium	26845	48.4%
apartment	15225	27.4%
executive	4562	8.2%
house	4443	8.0%
terrace	2760	5.0%
semi-detached	1225	2.2%
detached	458	0.8%

Most occurring characters

Value	Count	Frequency (%)
m	70140	12.9%
n	68915	12.7%
i	59477	10.9%
o	58133	10.7%
e	38903	7.2%
t	36695	6.8%
u	35850	6.6%
d	28528	5.2%
C	26845	4.9%
r	20745	3.8%
Other values (15)	99276	18.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	476534	87.7%
Uppercase Letter	56743	10.4%
Space Separator	9005	1.7%
Dash Punctuation	1225	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	70140	14.7%
n	68915	14.5%
i	59477	12.5%
o	58133	12.2%
e	38903	8.2%
t	36695	7.7%
u	35850	7.5%
d	28528	6.0%
r	20745	4.4%
a	19668	4.1%
Other values (6)	39480	8.3%

Uppercase Letter

Value	Count	Frequency (%)
C	26845	47.3%
A	15225	26.8%
E	4562	8.0%
H	4443	7.8%
T	2760	4.9%
D	1683	3.0%
S	1225	2.2%

Space Separator

Value	Count	Frequency (%)
	9005	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1225	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	533277	98.1%
Common	10230	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	70140	13.2%
n	68915	12.9%
i	59477	11.2%
o	58133	10.9%
e	38903	7.3%
t	36695	6.9%
u	35850	6.7%
d	28528	5.3%
C	26845	5.0%
r	20745	3.9%
Other values (13)	89046	16.7%

Common

Value	Count	Frequency (%)
	9005	88.0%
-	1225	12.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	543507	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
m	70140	12.9%
n	68915	12.7%
i	59477	10.9%
o	58133	10.7%
e	38903	7.2%
t	36695	6.8%
u	35850	6.6%
d	28528	5.2%
C	26845	4.9%
r	20745	3.8%
Other values (15)	99276	18.3%

Tenure
Categorical

Distinct	576
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Freehold	14231
99 Yrs From 31/05/2018	938
99 Yrs From 05/12/2016	620
99 Yrs From 31/07/2017	613
99 Yrs From 25/08/2014	599
Other values (571)	29512

Length

Max length	26
Median length	22
Mean length	17.733687
Min length	4

Characters and Unicode

Total characters	824847
Distinct characters	27
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	71 ?
Unique (%)	0.2%

Sample

1st row	99 Yrs From 31/05/1993
2nd row	99 Yrs From 03/03/2014
3rd row	99 Yrs From 08/03/2018
4th row	99 Yrs From 29/11/2011
5th row	99 Yrs From 05/03/2004

Common Values

Value	Count	Frequency (%)
Freehold	14231	30.6%
99 Yrs From 31/05/2018	938	2.0%
99 Yrs From 05/12/2016	620	1.3%
99 Yrs From 31/07/2017	613	1.3%
99 Yrs From 25/08/2014	599	1.3%
99 Yrs From 18/08/2017	598	1.3%
99 Yrs From 11/10/2017	579	1.2%
99 Yrs From 28/12/2016	535	1.2%
99 Yrs From 30/05/2016	531	1.1%
99 Yrs From 03/03/2014	516	1.1%
Other values (566)	26753	57.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
from	31984	22.4%
yrs	31984	22.4%
99	30299	21.2%
freehold	14231	9.9%
999	1599	1.1%
31/05/2018	938	0.7%
05/12/2016	620	0.4%
31/07/2017	613	0.4%
25/08/2014	599	0.4%
18/08/2017	598	0.4%
Other values (579)	29590	20.7%

Most occurring characters

Value	Count	Frequency (%)
	96576	11.7%
9	80949	9.8%
r	78494	9.5%
0	70683	8.6%
/	63968	7.8%
1	58583	7.1%
o	46510	5.6%
F	46215	5.6%
2	45046	5.5%
s	32574	3.9%
Other values (17)	205249	24.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	322425	39.1%
Lowercase Letter	263077	31.9%
Space Separator	96576	11.7%
Uppercase Letter	78795	9.6%
Other Punctuation	63974	7.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	80949	25.1%
0	70683	21.9%
1	58583	18.2%
2	45046	14.0%
8	14533	4.5%
5	12936	4.0%
7	11704	3.6%
3	10897	3.4%
6	9850	3.1%
4	7244	2.2%

Lowercase Letter

Value	Count	Frequency (%)
r	78494	29.8%
o	46510	17.7%
s	32574	12.4%
m	31984	12.2%
e	29347	11.2%
d	14526	5.5%
h	14526	5.5%
l	14526	5.5%
a	590	0.2%

Uppercase Letter

Value	Count	Frequency (%)
F	46215	58.7%
Y	32279	41.0%
L	295	0.4%
N	3	< 0.1%
A	3	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	63968	> 99.9%
.	6	< 0.1%

Space Separator

Value	Count	Frequency (%)
	96576	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	482975	58.6%
Latin	341872	41.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	78494	23.0%
o	46510	13.6%
F	46215	13.5%
s	32574	9.5%
Y	32279	9.4%
m	31984	9.4%
e	29347	8.6%
d	14526	4.2%
h	14526	4.2%
l	14526	4.2%
Other values (4)	891	0.3%

Common

Value	Count	Frequency (%)
	96576	20.0%
9	80949	16.8%
0	70683	14.6%
/	63968	13.2%
1	58583	12.1%
2	45046	9.3%
8	14533	3.0%
5	12936	2.7%
7	11704	2.4%
3	10897	2.3%
Other values (3)	17100	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	824847	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	96576	11.7%
9	80949	9.8%
r	78494	9.5%
0	70683	8.6%
/	63968	7.8%
1	58583	7.1%
o	46510	5.6%
F	46215	5.6%
2	45046	5.5%
s	32574	3.9%
Other values (17)	205249	24.9%

Completion Date
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	75
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Uncompleted	17282
2017	2625
2014	2014
2015	1987
2016	1896
Other values (70)	20709

Length

Max length	11
Median length	4
Mean length	6.6955475
Min length	4

Characters and Unicode

Total characters	311430
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	1996
2nd row	2018
3rd row	Uncompleted
4th row	2017
5th row	2008

Common Values

Value	Count	Frequency (%)
Uncompleted	17282	37.2%
2017	2625	5.6%
2014	2014	4.3%
2015	1987	4.3%
2016	1896	4.1%
Unknown	1468	3.2%
2013	1454	3.1%
2011	1235	2.7%
2009	1027	2.2%
2000	1018	2.2%
Other values (65)	14507	31.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
uncompleted	17282	37.2%
2017	2625	5.6%
2014	2014	4.3%
2015	1987	4.3%
2016	1896	4.1%
unknown	1468	3.2%
2013	1454	3.1%
2011	1235	2.7%
2009	1027	2.2%
2000	1018	2.2%
Other values (65)	14507	31.2%

Most occurring characters

Value	Count	Frequency (%)
e	34564	11.1%
0	30873	9.9%
2	23009	7.4%
1	22302	7.2%
n	21686	7.0%
U	18750	6.0%
o	18750	6.0%
l	17282	5.5%
p	17282	5.5%
t	17282	5.5%
Other values (12)	89650	28.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	181628	58.3%
Decimal Number	111052	35.7%
Uppercase Letter	18750	6.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	34564	19.0%
n	21686	11.9%
o	18750	10.3%
l	17282	9.5%
p	17282	9.5%
t	17282	9.5%
d	17282	9.5%
m	17282	9.5%
c	17282	9.5%
k	1468	0.8%

Decimal Number

Value	Count	Frequency (%)
0	30873	27.8%
2	23009	20.7%
1	22302	20.1%
9	13511	12.2%
7	4808	4.3%
8	3642	3.3%
5	3628	3.3%
4	3450	3.1%
6	3414	3.1%
3	2415	2.2%

Uppercase Letter

Value	Count	Frequency (%)
U	18750	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	200378	64.3%
Common	111052	35.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	34564	17.2%
n	21686	10.8%
U	18750	9.4%
o	18750	9.4%
l	17282	8.6%
p	17282	8.6%
t	17282	8.6%
d	17282	8.6%
m	17282	8.6%
c	17282	8.6%
Other values (2)	2936	1.5%

Common

Value	Count	Frequency (%)
0	30873	27.8%
2	23009	20.7%
1	22302	20.1%
9	13511	12.2%
7	4808	4.3%
8	3642	3.3%
5	3628	3.3%
4	3450	3.1%
6	3414	3.1%
3	2415	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	311430	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	34564	11.1%
0	30873	9.9%
2	23009	7.4%
1	22302	7.2%
n	21686	7.0%
U	18750	6.0%
o	18750	6.0%
l	17282	5.5%
p	17282	5.5%
t	17282	5.5%
Other values (12)	89650	28.8%

Type of Sale
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Resale	26302
New Sale	19593
Sub Sale	618

Length

Max length	8
Median length	6
Mean length	6.8690474
Min length	6

Characters and Unicode

Total characters	319500
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resale
2nd row	Sub Sale
3rd row	New Sale
4th row	New Sale
5th row	Resale

Common Values

Value	Count	Frequency (%)
Resale	26302	56.5%
New Sale	19593	42.1%
Sub Sale	618	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
resale	26302	39.4%
sale	20211	30.3%
new	19593	29.4%
sub	618	0.9%

Most occurring characters

Value	Count	Frequency (%)
e	92408	28.9%
a	46513	14.6%
l	46513	14.6%
R	26302	8.2%
s	26302	8.2%
S	20829	6.5%
	20211	6.3%
N	19593	6.1%
w	19593	6.1%
u	618	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	232565	72.8%
Uppercase Letter	66724	20.9%
Space Separator	20211	6.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	92408	39.7%
a	46513	20.0%
l	46513	20.0%
s	26302	11.3%
w	19593	8.4%
u	618	0.3%
b	618	0.3%

Uppercase Letter

Value	Count	Frequency (%)
R	26302	39.4%
S	20829	31.2%
N	19593	29.4%

Space Separator

Value	Count	Frequency (%)
	20211	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	299289	93.7%
Common	20211	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	92408	30.9%
a	46513	15.5%
l	46513	15.5%
R	26302	8.8%
s	26302	8.8%
S	20829	7.0%
N	19593	6.5%
w	19593	6.5%
u	618	0.2%
b	618	0.2%

Common

Value	Count	Frequency (%)
	20211	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	319500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	92408	28.9%
a	46513	14.6%
l	46513	14.6%
R	26302	8.2%
s	26302	8.2%
S	20829	6.5%
	20211	6.3%
N	19593	6.1%
w	19593	6.1%
u	618	0.2%

Purchaser Address Indicator
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Private	23438
HDB	16758
N.A	6317

Length

Max length	7
Median length	7
Mean length	5.0156085
Min length	3

Characters and Unicode

Total characters	233291
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private
2nd row	Private
3rd row	N.A
4th row	N.A
5th row	Private

Common Values

Value	Count	Frequency (%)
Private	23438	50.4%
HDB	16758	36.0%
N.A	6317	13.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
private	23438	50.4%
hdb	16758	36.0%
n.a	6317	13.6%

Most occurring characters

Value	Count	Frequency (%)
P	23438	10.0%
r	23438	10.0%
i	23438	10.0%
v	23438	10.0%
a	23438	10.0%
t	23438	10.0%
e	23438	10.0%
H	16758	7.2%
D	16758	7.2%
B	16758	7.2%
Other values (3)	18951	8.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	140628	60.3%
Uppercase Letter	86346	37.0%
Other Punctuation	6317	2.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	23438	27.1%
H	16758	19.4%
D	16758	19.4%
B	16758	19.4%
N	6317	7.3%
A	6317	7.3%

Lowercase Letter

Value	Count	Frequency (%)
r	23438	16.7%
i	23438	16.7%
v	23438	16.7%
a	23438	16.7%
t	23438	16.7%
e	23438	16.7%

Other Punctuation

Value	Count	Frequency (%)
.	6317	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	226974	97.3%
Common	6317	2.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	23438	10.3%
r	23438	10.3%
i	23438	10.3%
v	23438	10.3%
a	23438	10.3%
t	23438	10.3%
e	23438	10.3%
H	16758	7.4%
D	16758	7.4%
B	16758	7.4%
Other values (2)	12634	5.6%

Common

Value	Count	Frequency (%)
.	6317	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	233291	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	23438	10.0%
r	23438	10.0%
i	23438	10.0%
v	23438	10.0%
a	23438	10.0%
t	23438	10.0%
e	23438	10.0%
H	16758	7.2%
D	16758	7.2%
B	16758	7.2%
Other values (3)	18951	8.1%

Postal District
Real number (ℝ)

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.263819

Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	10
median	16
Q3	19
95-th percentile	27
Maximum	28
Range	27
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.9821349
Coefficient of variation (CV)	0.45743041
Kurtosis	-0.73023178
Mean	15.263819
Median Absolute Deviation (MAD)	5
Skewness	-0.16397876
Sum	709966
Variance	48.750208
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
19	6902	14.8%
15	3382	7.3%
5	2901	6.2%
18	2788	6.0%
3	2705	5.8%
23	2693	5.8%
14	2672	5.7%
10	2603	5.6%
27	2449	5.3%
9	2324	5.0%
Other values (17)	15094	32.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	426	0.9%
2	482	1.0%
3	2705	5.8%
4	547	1.2%
5	2901	6.2%
6	2	< 0.1%
7	224	0.5%
8	523	1.1%
9	2324	5.0%
10	2603	5.6%

Value	Count	Frequency (%)
28	1305	2.8%
27	2449	5.3%
26	433	0.9%
25	646	1.4%
23	2693	5.8%
22	819	1.8%
21	1412	3.0%
20	1409	3.0%
19	6902	14.8%
18	2788	6.0%

Postal Sector
Real number (ℝ)

Distinct	71
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.48365

Minimum	1
Maximum	82
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	26
median	46
Q3	56
95-th percentile	76
Maximum	82
Range	81
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	20.443256
Coefficient of variation (CV)	0.47013662
Kurtosis	-0.91740466
Mean	43.48365
Median Absolute Deviation (MAD)	14
Skewness	-0.052798936
Sum	2022555
Variance	417.92672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53	2898	6.2%
54	2394	5.1%
12	2020	4.3%
52	1916	4.1%
76	1798	3.9%
14	1421	3.1%
35	1399	3.0%
23	1374	3.0%
43	1347	2.9%
57	1211	2.6%
Other values (61)	28735	61.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	289	0.6%
5	13	< 0.1%
6	124	0.3%
7	322	0.7%
8	160	0.3%
9	419	0.9%
10	128	0.3%
11	732	1.6%
12	2020	4.3%
13	149	0.3%

Value	Count	Frequency (%)
82	539	1.2%
80	556	1.2%
79	749	1.6%
78	405	0.9%
77	28	0.1%
76	1798	3.9%
75	651	1.4%
73	646	1.4%
68	979	2.1%
67	535	1.2%

Postal Code
Real number (ℝ)

Distinct	9256
Distinct (%)	19.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	442652.27

Minimum	18965
Maximum	829750
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	363.5 KiB

Quantile statistics

Minimum	18965
5-th percentile	126751
Q1	266120
median	465462
Q3	567752
95-th percentile	769473
Maximum	829750
Range	810785
Interquartile range (IQR)	301632

Descriptive statistics

Standard deviation	204006.37
Coefficient of variation (CV)	0.46087274
Kurtosis	-0.90987655
Mean	442652.27
Median Absolute Deviation (MAD)	137481
Skewness	-0.047959029
Sum	2.0589085 × 10¹⁰
Variance	4.1618597 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126756	296	0.6%
148960	294	0.6%
148962	278	0.6%
158745	203	0.4%
149456	185	0.4%
237963	180	0.4%
357688	174	0.4%
149457	168	0.4%
126754	167	0.4%
533813	167	0.4%
Other values (9246)	44401	95.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18965	3	< 0.1%
18978	107	0.2%
18979	82	0.2%
18980	25	0.1%
18985	32	0.1%
18987	40	0.1%
58416	2	< 0.1%
59108	11	< 0.1%
68803	37	0.1%
68814	42	0.1%

Value	Count	Frequency (%)
829750	1	< 0.1%
829748	1	< 0.1%
829698	1	< 0.1%
829697	1	< 0.1%
829676	1	< 0.1%
829653	1	< 0.1%
829513	1	< 0.1%
829488	1	< 0.1%
828843	2	< 0.1%
828842	6	< 0.1%

Planning Region
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Central Region	21141
North East Region	8898
East Region	7309
West Region	5900
North Region	3265

Length

Max length	17
Median length	14
Mean length	13.581558
Min length	11

Characters and Unicode

Total characters	631719
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	East Region
2nd row	North East Region
3rd row	East Region
4th row	Central Region
5th row	Central Region

Common Values

Value	Count	Frequency (%)
Central Region	21141	45.5%
North East Region	8898	19.1%
East Region	7309	15.7%
West Region	5900	12.7%
North Region	3265	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
region	46513	45.6%
central	21141	20.7%
east	16207	15.9%
north	12163	11.9%
west	5900	5.8%

Most occurring characters

Value	Count	Frequency (%)
e	73554	11.6%
n	67654	10.7%
o	58676	9.3%
t	55411	8.8%
	55411	8.8%
R	46513	7.4%
g	46513	7.4%
i	46513	7.4%
a	37348	5.9%
r	33304	5.3%
Other values (7)	110822	17.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	474384	75.1%
Uppercase Letter	101924	16.1%
Space Separator	55411	8.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	73554	15.5%
n	67654	14.3%
o	58676	12.4%
t	55411	11.7%
g	46513	9.8%
i	46513	9.8%
a	37348	7.9%
r	33304	7.0%
s	22107	4.7%
l	21141	4.5%

Uppercase Letter

Value	Count	Frequency (%)
R	46513	45.6%
C	21141	20.7%
E	16207	15.9%
N	12163	11.9%
W	5900	5.8%

Space Separator

Value	Count	Frequency (%)
	55411	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	576308	91.2%
Common	55411	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	73554	12.8%
n	67654	11.7%
o	58676	10.2%
t	55411	9.6%
R	46513	8.1%
g	46513	8.1%
i	46513	8.1%
a	37348	6.5%
r	33304	5.8%
s	22107	3.8%
Other values (6)	88715	15.4%

Common

Value	Count	Frequency (%)
	55411	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	631719	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	73554	11.6%
n	67654	10.7%
o	58676	9.3%
t	55411	8.8%
	55411	8.8%
R	46513	7.4%
g	46513	7.4%
i	46513	7.4%
a	37348	5.9%
r	33304	5.3%
Other values (7)	110822	17.5%

Planning Area
Categorical

Distinct	39
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	363.5 KiB

Hougang	3813
Bedok	3588
Geylang	2573
Bukit Timah	2395
Queenstown	2377
Other values (34)	31767

Length

Max length	16
Median length	12
Mean length	8.5668738
Min length	5

Characters and Unicode

Total characters	398471
Distinct characters	44
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bedok
2nd row	Hougang
3rd row	Pasir Ris
4th row	Downtown Core
5th row	Bukit Merah

Common Values

Value	Count	Frequency (%)
Hougang	3813	8.2%
Bedok	3588	7.7%
Geylang	2573	5.5%
Bukit Timah	2395	5.1%
Queenstown	2377	5.1%
Clementi	2091	4.5%
Tampines	2066	4.4%
Serangoon	2038	4.4%
Toa Payoh	1954	4.2%
Sengkang	1877	4.0%
Other values (29)	21741	46.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bukit	6129	9.6%
hougang	3813	6.0%
bedok	3588	5.6%
geylang	2573	4.0%
timah	2395	3.7%
queenstown	2377	3.7%
clementi	2091	3.3%
tampines	2066	3.2%
serangoon	2038	3.2%
toa	1954	3.1%
Other values (42)	34844	54.6%

Most occurring characters

Value	Count	Frequency (%)
a	41414	10.4%
n	40759	10.2%
e	32818	8.2%
o	29948	7.5%
g	24017	6.0%
i	23295	5.8%
	17369	4.4%
u	16597	4.2%
t	14347	3.6%
k	12953	3.3%
Other values (34)	144954	36.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	317234	79.6%
Uppercase Letter	63868	16.0%
Space Separator	17369	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	41414	13.1%
n	40759	12.8%
e	32818	10.3%
o	29948	9.4%
g	24017	7.6%
i	23295	7.3%
u	16597	5.2%
t	14347	4.5%
k	12953	4.1%
l	12498	3.9%
Other values (12)	68588	21.6%

Uppercase Letter

Value	Count	Frequency (%)
B	12156	19.0%
T	7513	11.8%
P	5868	9.2%
S	5290	8.3%
C	4926	7.7%
H	3813	6.0%
R	3635	5.7%
M	3607	5.6%
K	3136	4.9%
G	2573	4.0%
Other values (11)	11351	17.8%

Space Separator

Value	Count	Frequency (%)
	17369	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	381102	95.6%
Common	17369	4.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	41414	10.9%
n	40759	10.7%
e	32818	8.6%
o	29948	7.9%
g	24017	6.3%
i	23295	6.1%
u	16597	4.4%
t	14347	3.8%
k	12953	3.4%
l	12498	3.3%
Other values (33)	132456	34.8%

Common

Value	Count	Frequency (%)
	17369	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	398471	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	41414	10.4%
n	40759	10.2%
e	32818	8.2%
o	29948	7.5%
g	24017	6.0%
i	23295	5.8%
	17369	4.4%
u	16597	4.2%
t	14347	3.6%
k	12953	3.3%
Other values (34)	144954	36.4%

Auto

Heatmap
Table

	No. of Units	Area (sqm)	Transacted Price ($)	Unit Price ($ psm)	Unit Price ($ psf)	Postal District	Postal Sector	Postal Code	Type of Area	Property Type	Completion Date	Type of Sale	Purchaser Address Indicator	Planning Region	Planning Area
No. of Units	1.000	0.073	0.073	0.040	0.040	-0.021	-0.021	-0.021	0.000	0.000	0.054	0.009	0.013	0.006	0.026
Area (sqm)	0.073	1.000	0.732	-0.312	-0.312	0.068	0.066	0.072	0.000	0.000	0.061	0.009	0.010	0.005	0.030
Transacted Price ($)	0.073	0.732	1.000	0.346	0.346	-0.337	-0.332	-0.328	0.000	0.000	0.062	0.012	0.013	0.009	0.040
Unit Price ($ psm)	0.040	-0.312	0.346	1.000	1.000	-0.589	-0.578	-0.580	0.045	0.232	0.168	0.182	0.168	0.329	0.335
Unit Price ($ psf)	0.040	-0.312	0.346	1.000	1.000	-0.589	-0.578	-0.580	0.045	0.233	0.169	0.182	0.168	0.329	0.335
Postal District	-0.021	0.068	-0.337	-0.589	-0.589	1.000	0.988	0.987	0.186	0.248	0.216	0.262	0.236	0.724	0.848
Postal Sector	-0.021	0.066	-0.332	-0.578	-0.578	0.988	1.000	1.000	0.163	0.241	0.230	0.257	0.239	0.676	0.866
Postal Code	-0.021	0.072	-0.328	-0.580	-0.580	0.987	1.000	1.000	0.164	0.242	0.230	0.253	0.237	0.675	0.863
Type of Area	0.000	0.000	0.000	0.045	0.045	0.186	0.163	0.164	1.000	0.902	0.635	0.221	0.176	0.106	0.303
Property Type	0.000	0.000	0.000	0.232	0.233	0.248	0.241	0.242	0.902	1.000	0.323	0.253	0.212	0.274	0.394
Completion Date	0.054	0.061	0.062	0.168	0.169	0.216	0.230	0.230	0.635	0.323	1.000	0.710	0.368	0.225	0.196
Type of Sale	0.009	0.009	0.012	0.182	0.182	0.262	0.257	0.253	0.221	0.253	0.710	1.000	0.352	0.144	0.382
Purchaser Address Indicator	0.013	0.010	0.013	0.168	0.168	0.236	0.239	0.237	0.176	0.212	0.368	0.352	1.000	0.176	0.291
Planning Region	0.006	0.005	0.009	0.329	0.329	0.724	0.676	0.675	0.106	0.274	0.225	0.144	0.176	1.000	1.000
Planning Area	0.026	0.030	0.040	0.335	0.335	0.848	0.866	0.863	0.303	0.394	0.196	0.382	0.291	1.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Project Name	Address	No. of Units	Area (sqm)	Type of Area	Transacted Price ($)	Nett Price($)	Unit Price ($ psm)	Unit Price ($ psf)	Sale Date	Property Type	Tenure	Completion Date	Type of Sale	Purchaser Address Indicator	Postal District	Postal Sector	Postal Code	Planning Region	Planning Area
0	THE BAYSHORE	22 Bayshore Road #03-02	1	88	Strata	888000	-	10091	937	28-FEB-2019	Condominium	99 Yrs From 31/05/1993	1996	Resale	Private	16	46	469970	East Region	Bedok
1	KINGSFORD WATERBAY	66 Upper Serangoon View #16-12	1	102	Strata	1280000	-	12549	1166	28-FEB-2019	Apartment	99 Yrs From 03/03/2014	2018	Sub Sale	Private	19	53	533885	North East Region	Hougang
2	THE JOVELL	13 Flora Drive #02-11	1	42	Strata	615000	-	14643	1360	28-FEB-2019	Condominium	99 Yrs From 08/03/2018	Uncompleted	New Sale	N.A	17	50	506853	East Region	Pasir Ris
3	V ON SHENTON	5A Shenton Way #44-12	1	112	Strata	2855680	2847680	25426	2362	28-FEB-2019	Apartment	99 Yrs From 29/11/2011	2017	New Sale	N.A	1	6	68814	Central Region	Downtown Core
4	THE BEACON	130 Cantonment Road #10-04	1	103	Strata	1570000	-	15243	1416	28-FEB-2019	Apartment	99 Yrs From 05/03/2004	2008	Resale	Private	2	8	89775	Central Region	Bukit Merah
5	WATERBANK AT DAKOTA	78 Dakota Crescent #09-16	1	58	Strata	1080000	-	18621	1730	28-FEB-2019	Condominium	99 Yrs From 07/12/2009	2013	Resale	Private	14	39	399945	Central Region	Geylang
6	MARGARET VILLE	20 Margaret Drive #15-03	1	85	Strata	1560650	-	18361	1706	28-FEB-2019	Apartment	99 Yrs From 13/03/2017	Uncompleted	New Sale	N.A	3	14	149312	Central Region	Queenstown
7	PARK COLONIAL	4 Woodleigh Lane #10-12	1	63	Strata	1359000	-	21571	2004	28-FEB-2019	Condominium	99 Yrs From 11/10/2017	Uncompleted	New Sale	N.A	13	35	357686	Central Region	Toa Payoh
8	BREEZE BY THE EAST	316 Upper East Coast Road #04-03	1	116	Strata	1530000	-	13190	1225	28-FEB-2019	Condominium	Freehold	2011	Resale	Private	16	46	465520	East Region	Bedok
9	THE TRE VER	64 Potong Pasir Avenue 1 #14-24	1	65	Strata	1127112	-	17340	1611	28-FEB-2019	Condominium	99 Yrs From 27/03/2018	Uncompleted	New Sale	N.A	13	35	358393	Central Region	Toa Payoh

	Project Name	Address	No. of Units	Area (sqm)	Type of Area	Transacted Price ($)	Nett Price($)	Unit Price ($ psm)	Unit Price ($ psf)	Sale Date	Property Type	Tenure	Completion Date	Type of Sale	Purchaser Address Indicator	Postal District	Postal Sector	Postal Code	Planning Region	Planning Area
46503	EAST MEADOWS	32 Tanah Merah Kechil Road #03-23	1	111	Strata	1090000	-	9820	912	01-AUG-2018	Condominium	99 Yrs From 02/03/1998	2002	Resale	HDB	16	46	465559	East Region	Bedok
46504	SIMSVILLE	10 Geylang East Avenue 2 #03-08	1	91	Strata	960000	-	10549	980	01-AUG-2018	Condominium	99 Yrs From 01/12/1994	1998	Resale	Private	14	38	389758	Central Region	Geylang
46505	THE COAST AT SENTOSA COVE	276 Ocean Drive #03-26	1	244	Strata	4688000	-	19213	1785	01-AUG-2018	Condominium	99 Yrs From 11/04/2006	2009	Resale	Private	4	9	98449	Central Region	Southern Islands
46506	CLEMENTI GREEN	38 Clementi Crescent	1	228	Land	3050000	-	13401	1245	01-AUG-2018	Terrace House	Freehold	1978	Resale	Private	21	59	599552	Central Region	Bukit Timah
46507	CASTLE GREEN	485 Yio Chu Kang Road #04-16	1	88	Strata	810000	-	9205	855	01-AUG-2018	Condominium	99 Yrs From 01/12/1993	1997	Resale	Private	26	78	787058	North East Region	Ang Mo Kio
46508	PRIVE	37 Punggol Field #03-36	1	77	Strata	828000	-	10753	999	01-AUG-2018	Executive Condominium	99 Yrs From 14/09/2010	2013	Resale	HDB	19	82	828809	North East Region	Punggol
46509	PARK GREEN	12 Rivervale Link #17-21	1	193	Strata	1470000	-	7617	708	01-AUG-2018	Executive Condominium	99 Yrs From 17/08/2001	2004	Resale	HDB	19	54	545045	North East Region	Sengkang
46510	PRIVE	37 Punggol Field #09-35	1	77	Strata	770000	-	10000	929	01-AUG-2018	Executive Condominium	99 Yrs From 14/09/2010	2013	Resale	Private	19	82	828809	North East Region	Punggol
46511	EIGHT COURTYARDS	12 Canberra Drive #11-24	1	106	Strata	1100000	-	10377	964	01-AUG-2018	Condominium	99 Yrs From 20/09/2010	2014	Resale	Private	27	76	768094	North Region	Yishun
46512	BARTLEY RESIDENCES	3A Lorong How Sun #09-19	1	99	Strata	1420000	-	14343	1333	01-AUG-2018	Apartment	99 Yrs From 29/06/2011	2015	Resale	Private	19	53	536561	North East Region	Serangoon

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block